Re: won't drop the view

Hi Oleg,
At 19:28 -0700 12/14/2001, Oleg Lebedev wrote:
>Hi everybody,
>I just vacuumed and vacuumed analyzed my database. Now, I am trying to
>execute a view, which was perfectly working before, but it seems to be
>very slow. It was sitting there for 10 mins before I cancelled it.
>Usually it was taking on the order of 5 secs to execute the view.
>I just recreated the view, but the problem still persists.
>Here is what EXPLAIN tells me:
>EXPLAIN select * from progress_report;
>Subquery Scan progress_report  (cost=16386.56..16386.56 rows=2
>width=128)
>   ->  Sort  (cost=16386.56..16386.56 rows=2 width=128)
>         ->  Nested Loop  (cost=16299.45..16386.55 rows=2 width=128)
>
>How can I "restore" the "before-the-vacuum" performance?
>thanks,

I don't know much about the internal workings about 'vacuum'. My 
guess is that there is something wrong with one of the indexes in 
your db somewhere. I would try and rebuild them - starting with the 
ones involved in the view. You might have to drop and re-create them 
- as well as the view.

Good luck,
Chris
-- 
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com